package com.ycMc.mapper;

import com.ycMc.domain.InStock;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * Created by libo2 on 2017/12/6.
 */
@Repository
public interface InStockMapper {

    public void insert(InStock inStock);

    public void update(InStock inStock);

    public void delete(@Param("id")int id);

    public List<InStock> select(@Param("productId")String productId,
                                @Param("productName")String productName,
                                @Param("productVersion")String productVersion,
                                @Param("addNumber")int addNumber,
                                @Param("inStockPrice")double inStockPrice,
                                @Param("supplier")String supplier,
                                @Param("productBrand")String productBrand,
                                @Param("startTime")long startTime,
                                @Param("endTime")long endTime,
                                @Param("offset")int offset,
                                @Param("pageSize")int pageSize);

    public List<InStock> query(@Param("queryKeyword")String queryKeyword,@Param("productBrand")String productBrand,@Param("startTime")long startTime,@Param("endTime")long endTime,@Param("offset")int offset,@Param("pageSize")int pageSize,@Param("productId")String productId);

    public InStock selectOne(@Param("id")int id);



}
